Film_Locations_in_San_Francisco

8 rows where Release Year = 53

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
623	623	Guess Who's Coming to Dinner 111	1967 53	Sutter Street between Powell and Mason		Columbia Pictures Corporation 5	Columbia Pictures 4	Stanley Kramer 103	William Rose 103	Spencer Tracy 315	Sidney Poitier 90	Katharine Hepburn 484
624	624	Guess Who's Coming to Dinner 111	1967 53	San Francisco International Airport	SFO has a museum dedicated to aviation history.	Columbia Pictures Corporation 5	Columbia Pictures 4	Stanley Kramer 103	William Rose 103	Spencer Tracy 315	Sidney Poitier 90	Katharine Hepburn 484
625	625	Guess Who's Coming to Dinner 111	1967 53	Mel's Drive-In (Corner South Van Ness & Mission St.)	This restaurant location was demolished; however another Mel's was reopened in 1986 on 3355 Geary Blvd.	Columbia Pictures Corporation 5	Columbia Pictures 4	Stanley Kramer 103	William Rose 103	Spencer Tracy 315	Sidney Poitier 90	Katharine Hepburn 484
626	626	Guess Who's Coming to Dinner 111	1967 53	634 Raycliff Terrace		Columbia Pictures Corporation 5	Columbia Pictures 4	Stanley Kramer 103	William Rose 103	Spencer Tracy 315	Sidney Poitier 90	Katharine Hepburn 484
1032	1032	Point Blank 194	1967 53	Fort Point (Presidio, Golden Gate National Recreation Area)	Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF.	Metro-Goldwyn Mayer 8	Metro-Goldwyn Mayer 10	John Boorman 163	Alexander Jacobs 167	Lee Marvin 363	Angie Dickinson 149	Keenan Wynn 509
1033	1033	Point Blank 194	1967 53	Alcatraz Island	Alcatraz Island was a military fort before it became a prison.	Metro-Goldwyn Mayer 8	Metro-Goldwyn Mayer 10	John Boorman 163	Alexander Jacobs 167	Lee Marvin 363	Angie Dickinson 149	Keenan Wynn 509
1418	1418	The Graduate 259	1967 53	San Francisco Zoo (2701 Sloat Blvd.)		Embassy Pictures Corporation 157	Embassy Pictures Corporation 111	Mike Nichols 214	Calder Willingham 225	Anne Bancroft 404	Dustin Hoffman 197	Katharine Ross 533
1419	1419	The Graduate 259	1967 53	Bay Bridge	Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII.	Embassy Pictures Corporation 157	Embassy Pictures Corporation 111	Mike Nichols 214	Calder Willingham 225	Anne Bancroft 404	Dustin Hoffman 197	Katharine Ross 533

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");